This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
Yes, this can be done. In the last year I have tried several different mail merge code posted in forums which is similar to the Word "Mail Merge to E-mail Messages" feature. I got some of them working, but for the most part they are not very user friendly, initially require Domino Developer set-up, offer insufficient mail merge logging, and a nightmare to maintain since not centrally controlled -- meaning not allowing the end user to cripple your network with an email blast festival. LOL. It would be nice to enable/disable the user's mail merge access with a single click which seems to require a 3rd party add-on...
Anyway, a 3rd party product seems to make more sense unless you plan on doing a one time "small" mail merge email blast. My customer needed to allow multiple users to send email merges to 100's of people on a monthly basis. We started using Print Merge Reporter which was user friendly and most importantly centrally controlled with nice logging. The web site is below, but since the software also has other functionality such as reporting and stuff this press release we got is easier to understand: http://www.notesmail.com/home.nsf/mailer20140311
For those of you interested in importing Excel data into Notes here are some tips I learned over the last year while doing email merges. This will save you some headaches and hair. :) Enjoy and "stay thirsty my friends"...
INSTRUCTIONS for importing Excel data into a Notes database
1. You will first need to save the Excel spreadsheet in Lotus 1-2-3 (.WK4) format. If you are using an Excel verion earlier than 2003 SP3, then simple click File - Save As - Lotus 123 (.WK4). If you are using Excel 2003 SP3 the default security options blocks saving the spreadsheet as Lotus 1-2-3 (.WK4). You can unblock as seen below. If you are using Excel 2007 or higher it no longer supports savings as 1-2-3, so you must either (1) copy/paste the spreadsheet into another spreadsheet application (i.e. Lotus 1-2-3, Quattro Pro) to save it as Lotus 1-2-3 (.WK4) format, or (2) Save it as a CSV file, then open in another spreadsheet application to save it as Lotus 1-2-3 (.WK4) format.
Instructions to enable Excel 2003 SP3 to save as Lotus 1-2-3 WK4 format:
A. To re-enable Excel file types only, save the following file to a folder on the computer: http://download.microsoft.com/download/2/8/B/28B644CE-9A30-4D99-AFEF-830A4FB5B839/UnblockExcel.reg
B. Double-click the file that you saved in step A.
C. Click Yes to confirm the installation of the file.
D. If an Office program is running, restart the Office program.
After you install the update, the registry settings will be updated to allow you to open and to save all file types that are supported by Microsoft Office 2003. These file types include the file types that are blocked by default in Office 2003 SP3.
(More Info: http://support.microsoft.com/kb/938810/)
2. Create a Notes view in a database that has the same number of columns as the Excel data columns. Each Notes column should have a unique field name assigned to it.
3. Open the Notes view, then click File - Import. Select the folder containing the the Lotus 123 (.WK4) you saved in step 1. Click Files of type "Lotus 1-2-3", then select the file and click Import - OK.
tags: mailmerge excel to notes, mail merge to email using lotus notes, mail merge excel to notes, email mail merge in lotus notes, lotus notes mail merge, mail merge to email using lotus notes, mass mailing tool for lotus notes, mail merge mass mailings, personalized mass mailer, lotus notes bulk email, mass email delivery in Domino, mass mailings - lotus, lotus notes mail merge from a microsoft excel spreadsheet
Crucial tools for IBM Lotus Notes and Domino administration and development...
Find the "crucial tools you need to succeed" including product descriptions, downloads, demos and testimonials.
Speed up IBM Lotus Notes and Domino administration and development with these crucial software tools. Better, stronger, faster productivity for administrators and developers. Download and try the lite (free) version
Feedback response number WEBB9LWPDT created by ~Paul Oprevitchikle on 07/11/2014
Mail merge (~Nicole Fezboos... 26.Aug.08) . . Not without some programming (~Nita Nimfreeso... 26.Aug.08) . . Mail Merge Excel to Lotus Notes (~Paul Oprevitch... 11.Jul.14)
Mail Merge Excel to Lotus Notes
Return to top
. . Mail Merge Excel to Lotus Notes (~Paul Oprevitch... 11.Jul.14) 
